Informix
The following table lists the data types that the ODBC driver supports for Informix:
Table B-2. Mapping Informix Data Types to ODBC Data Types
|
Informix Data Type
|
ODBC Data Type
|
|
BLOB
|
SQL_LONGVARBINARY
|
|
BOOLEAN
|
SQL_BIT
|
|
BYTE
|
SQL_LONGVARBINARY
|
|
CHAR
|
SQL_CHAR
|
|
CLOB
|
SQL_LONGVARCHAR
|
|
DATE
|
SQL__TYPE_DATE
|
|
DATETIME HOUR TO SECOND
|
SQL__TYPE_TIME
|
|
DATETIME YEAR TO FRACTION(5)
|
SQL__TYPE_TIMESTAMP
|
|
DECIMAL
|
SQL_DECIMAL
|
|
FLOAT
|
SQL_FLOAT
|
|
INTEGER
|
SQL_INTEGER
|
|
INT8
|
SQL_BIGINT
|
|
LVARCHAR
|
SQL_LONGVARCHAR
|
|
MONEY
|
SQL_DECIMAL
|
|
NUMERIC
|
SQL_NUMERIC
|
|
SERIAL
|
SQL_INTEGER
|
|
SERIAL8
|
SQL_BIGINT
|
|
SMALLFLOAT
|
SQL_REAL
|
|
SMALLINT
|
SQL_SMALLINT
|
|
TEXT
|
SQL_LONGVARCHAR
|
|
VARCHAR
|
SQL_VARCHAR
|